package com.example.demo.mapper;

import com.example.demo.entity.Source;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ClassAvgMapper {

//  1每个专业每个班级的平均分
    @Select("select stu_class,avg(total_score) as avgScore from dashuju GROUP BY stu_class")
    List<Source> classDashujuAvg();//大数据

    @Select("select stu_class,avg(total_score) as avgScore from jisuanjiyingyong GROUP BY stu_class")
    List<Source> classJisuanjiyingyongAvg();//计算机应用

    @Select("select stu_class,avg(total_score) as avgScore from ruanjiangongcheng GROUP BY stu_class")
    List<Source> classRuanjiangongchengAvg();//软件工程

    @Select("select stu_class,avg(total_score) as avgScore from ruanjianjishu GROUP BY stu_class")
    List<Source> classRuanjianjishuAvg();//软件技术

    @Select("select stu_class,avg(total_score) as avgScore from wangluogongcheng GROUP BY stu_class")
    List<Source> classWangluogongchengAvg();//网络工程

    @Select("select stu_class,avg(total_score) as avgScore from wangluojishu GROUP BY stu_class")
    List<Source> classWangluojishuAvg();//网络技术

    @Select("select stu_class,avg(total_score) as avgScore from wulianwang GROUP BY stu_class")
    List<Source> classWulianwangAvg();//物联网

    @Select("select stu_class,avg(total_score) as avgScore from xinxiguanli GROUP BY stu_class")
    List<Source> classXinxiguanliAvg();//信息管理


}
